Declare @Id Int                               

Select @Id = Id From sysobjects Where Name = 'Level_Header'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Header Add Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 


Select @Id = Id From sysobjects Where Name = 'Level_Detail1'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Detail1 Add Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'Level_Detail2'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Detail2 Add Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'Level_Detail3'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Detail3 Add Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'Level_Detail4'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Detail4 Add Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'Level_Detail5'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Detail5 ADD Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'Level_Link'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Id')
  Alter Table Level_Link ADD Id UNIQUEIDENTIFIER DEFAULT(NEWID()) NOT NULL 

Select @Id = Id From sysobjects Where Name = 'History_Price'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'Price_Internet')
  Alter Table History_Price Add Price_Internet MONEY
